drop table if exists customers;
create table customers(
	id integer not null primary key,
	name varchar(45),
	address varchar(45),
	phone varchar(45),
	trade_assistance varchar(45),
	classification varchar(45),
	type_of_deal varchar(45),
	balance double,
	inactive boolean,
	company_name varchar(45),
	balance_as_of datetime,
	title varchar(45),
	first_name varchar(45),
	last_name varchar(45),
	middle_name varchar(45),
	ship_to_address varchar(45),
	contact varchar(45),
	fax varchar(45),
	alt_phone varchar(45),
	alt_contact varchar(45),
	email varchar(45),
	cc varchar(45),
	customer_type_id integer,
	terms_id integer,
	sales_rep_id integer,
	send_method smallint,
	sales_tax_code_id integer,
	tax_item_id integer,
	resale_number varchar(45),
	price_level_id integer,
	account_no varchar(45),
	credit_limit double,
	payment_method_id integer,
	credit_card_no varchar(45),
	cc_expiry_month varchar(45),
	cc_expiry_year varchar(45),
	name_on_card varchar(45),
	cc_address varchar(45),
	cc_zip_code varchar(45),
	job_status smallint,
	start_date datetime,
	projected_end datetime,
	end_date datetime,
	job_description varchar(45),
	job_type_id integer,
	notes mediumtext
);